| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
   |
Posted - 2017.03.09 21:45:15 -
[1] - Quote
Hello,
i'm trying to use API too, but i fail when i search for citadel market data, and i didn't find it on your website.
Is it still possible to get it ?
Thx ! |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.12 18:49:41 -
[2] - Quote
Steve Ronuken wrote:Right now, I'm not providing an API which gives order data down to that level.
If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that.
Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this.
Maybe i did wrong or corp can hide it ? |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.12 21:29:44 -
[3] - Quote
Steve Ronuken wrote:Amodos Oblivion wrote:Steve Ronuken wrote:Right now, I'm not providing an API which gives order data down to that level.
If you want to pull a specific citadel's data, you'll have to do that yourself. Sorry about that. Ok, but it's look like to have this data, you need structureID, but how get it ? I tried with ESI and the response was that it was private, or something like this. Maybe i did wrong or corp can hide it ? The easiest way to get a structure ID is by bookmark, by job, by market order or by asset. (there is a list of public structures. but you need to look at each one to find out where it is) You also have to authenticate with SSO to be able to retrieve market orders from structures, with ESI. (this is so it can handle private markets) That auth requirement makes it somewhat harder to manage in powerquery (I've yet to get that working. but I've only put in a few hours). Doing it with googledocs shouldn't be too hard. doing it in excel with xlwings should be dead easy.
Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.12 21:43:00 -
[4] - Quote
Steve Ronuken wrote:Amodos Oblivion wrote:
Ok thanks i get it !
But as you said, to get the market of a structure we need SSO connection, and is it possible to do it with googlesheet ? If it's possible and you have any tuto :D
No tutorial at the moment. It's entirely possible to do though. First you set up a new application on developers.eveonline.com, with the appropriate scopes. Then you use something like postman ( https://www.getpostman.com/ ) to do the initial authentication, to get the refresh token. Then, finally, in google sheets, you write a custom function which uses that refresh token to authenticate, then retrieve the data. I'll try and get something written up.
xD
I'll watch it, looks like pretty cool but hard to make :D
Btw, thx for reactivity, you're insane bro ! |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.14 19:43:55 -
[5] - Quote
Hello again,
i did what you said, use postman to get token. Btw, postman is really cool.
Then, i still use it to get the json market data.
I wanted to use a a script to extract data from this json (https://gist.github.com/paulgambill/cacd19da95a1421d3164)
I saved the json on my computer, but can't access it from googlesheet without if it's not on web, so i tried to use a site to store it (http://myjson.com/) but the file is too big.
i'm actully blocked, what can i do ? |
Amodos Oblivion
Pandemic Horde Inc.
Pandemic Horde
0
|
Posted - 2017.03.14 20:50:02 -
[6] - Quote
Steve Ronuken wrote:https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/
Finally got round to writing it :D
<3 Thx |
| |
|